CREATE EXTERNAL TABLE jms_dwd.dwd_tab_barscan_noparsepackage_base_dt(
    record_id string comment'记录编号_ef',
    waybill_no string comment'运单编号_ef',
    scan_time timestamp comment'扫描时间_ef',
    input_time timestamp comment'入库时间_ef',
    scan_user string comment'扫描雇员_ef',
    input_site string comment'录入部门_ef',
    scan_type string comment'扫描类型_ef',
    next_station string comment'上一站或下一站_ef',
    project_flag tinyint comment'项目标识_ef',
    process_flag tinyint comment'处理标识_ef',
    weight double comment'重量',
    remark string comment'备注',
    mobile string comment'手机号码',
    pistol_id string comment'巴枪ID_ef',
    remark1 string comment'备注1',
    remark2 string comment'备注2',
    destination string comment'目的地点',
    shifts string comment'班次',
    send_site string comment'寄件网点',
    scan_site_code string comment'扫描网点编号_ef',
    upload_time timestamp comment'上传时间_ef',
    remark3 string comment'备注3',
    scan_user_code string comment'扫描雇员编号_ef',
    send_deliver_user_code string comment'收派员编号',
    next_station_code string comment'上下一站编号_ef',
    source string comment'来源_ef',
    remark4 string comment'备注4',
    remark5 string comment'备注5',
    remark6 double comment'备注6',
    scan_site_id bigint comment'扫描网点ID_ef',
    next_station_id bigint comment'上一站/下一站ID_ef',
    scan_user_id bigint comment'扫描雇员ID_ef',
    send_deliver_user_id bigint comment'收派员ID',
    shipment_no string comment'任务号(装车、卸车)、订舱号(到件、发件)_ef',
    transport_type string comment'运输方式_ef',
    network_type tinyint comment "扫描网点类型，1.加盟商,2.转运中心,3.集散点,4.普通网点,5.代理区,6.总部,0.其他",
    site_agent_code string comment "所属代理区code",
    site_agent_name  string comment "所属代理区名称",
    site_franchisee_code  string comment "所属加盟商code ",
    site_franchisee_name  string comment "所属加盟商名称",
    site_transcenter_code string comment "所属转运中心code",
    site_transcenter_name string comment "所属转运中心名称",
    next_network_type tinyint comment "下一站网点类型，1.加盟商,2.转运中心,3.集散点,4.普通网点,5.代理区,6.总部,0.其他",
    waybill_source string comment "运单来源：GB:国标单号,BS:百世单号,BSB:百世包号,JT:极兔单号,JTB:极兔包号,Other:其它"
)
COMMENT '操作平台-延迟包内件数据表'
PARTITIONED BY (
  `dt` string COMMENT '时间分区-inputtime')
stored as parquet
location "/dw/hive/jms_dwd.db/external/dwd_tab_barscan_noparsepackage_base_dt"
